2013-04-04 - 5910.200 - Rel Notes - Contracts - Release 020 #BIReleases2013

Release Notes:

‍5910.200 - Contracts - EPM230

Admin Info


Purpose
Including Contract Information in EPM230 - Product Mix Scorecard
Release No
020
Submitted
04-04-2013
Submitted by
Mallareddy D
Source/Destination Systems
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
Mark Harris
Object(s) Created By
Narendra Koraganji
Object(s) Tested By
Narendra Koraganji

Report Name


EPM230 - Product Mix Scorecard

BEx Query


ZMP_OPASA_Q001
ZMP_OPASA_Q002
ZMP_OPASA_Q003
ZMP_OPASA_Q004
ZMP_OPASA_Q005
ZMP_OPASA_Q006
ZMP_OPASA_Q007
ZMP_OPASA_Q008
ZMP_OPASA_Q009
ZMP_OPASA_Q010
ZMP_OPASA_Q011
ZMP_OPASA_Q012

NEC Crystal Reports Standards Check


1. EPM230 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. EPM230 NEC CR checklist has been sent to NEC and also attached here for reference:
EPM230 NEC CR Standard Check List.xlsx

Summary Level Check


Test Conducted

Group: North America
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
65,895,548
65,895,548
Pass
2
Last Year Shipped YTD
49,535,432
49,535,432
Pass
3
Current Year Budget YTD
81,480,846
81,480,846
Pass
4
Total Open Revenue
128,132,426
128,132,426
Pass
5
Total Shipped Current Year
194,027,973
194,027,973
Pass
6
Total Shipped Last Year
447,596,834
447,596,834
Pass
7
Total Budget Current Year
516,707,703
516,707,703
Pass
8
TY Quantity
5,913,844
5,913,844
Pass
9
LY Quantity
4,735,464
4,735,464
Pass
10
Budget Quantity
0
0
Pass

License Subreport : MLB Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
36,077,617
36,077,617
Pass
2
Open
40,517,831
40,517,831
Pass
3
Total
76,595,447
76,595,447
Pass
4
Last Year
30,673,492
30,673,492
Pass
5
Budget
41,006,366
41,006,366
Pass
6
TY Quantity
3,041,465
3,041,465
Pass
7
LY Quantity
2,539,906
2,539,906
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : NATIONAL KEY ACCOUNTS
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
18,786,617
18,786,617
Pass
2
Open
33,545,272
33,545,272
Pass
3
Total
52,327,989
52,327,989
Pass
4
Last Year
16,828,543
16,828,543
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,499,548
1,499,548
Pass
7
LY Quantity
1,370,790
1,370,790
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : LIDS INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
15,119,373
15,119,373
Pass
2
Open
27,515,165
27,515,165
Pass
3
Total
42,634,538
42,634,538
Pass
4
Last Year
11,489,793
11,489,793
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,202,231
1,202,231
Pass
7
LY Quantity
931,121
931,121
Pass
8
Budget Quantity
0
0
Pass

Silhouette Subreport : 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
31,047,681
31,047,681
Pass
2
Open
39,696,017
39,696,017
Pass
3
Total
70,743,699
70,743,699
Pass
4
Last Year
28,811,657
28,811,657
Pass
5
Budget
38,980,491
38,980,491
Pass
6
TY Quantity
2,106,764
2,106,764
Pass
7
LY Quantity
2,304,102
2,304,102
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
14,315,104
14,315,104
Pass
2
Open
38,401,326
38,401,326
Pass
3
Total
52,716,430
52,716,430
Pass
4
Last Year
10,890,258
10,890,258
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,880,401
1,880,401
Pass
7
LY Quantity
1,490,916
1,490,916
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
42,158,008
42,158,008
Pass
2
Last Year Shipped MTD
34,323,003
34,323,003
Pass
3
Budget Current Year MTD
0
0
Pass
4
TY Quantity Current Year MTD
3,649,036
3,649,036
Pass
5
LY Quantity Last Year MTD
3,201,655
3,201,655
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

License Month Subreport : NBA Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
4,819,412
4,819,412
Pass
2
Open
170,574
170,574
Pass
3
Total
4,989,986
4,989,986
Pass
4
Last Year
4,152,066
4,152,066
Pass
5
Budget
3,102,811
3,102,811
Pass
6
TY Quantity
410,101
410,101
Pass
7
LY Quantity
362,021
362,021
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : NATIONAL KEY ACCOUNTS
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
17,071,764
17,071,764
Pass
2
Open
0
0
Pass
3
Total
17,071,764
17,071,764
Pass
4
Last Year
15,512,458
15,512,458
Pass
5
Budget
0
0
Pass
8
TY Quantity
1,352,568
1,352,568
Pass
9
LY Quantity
1,254,793
1,254,793
Pass
10
Budget Quantity
0
0
Pass

Customer Subreport : CHAMPS DIVISION
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
1,746,159
1,746,159
Pass
2
Open
0
0
Pass
3
Total
1,746,159
1,746,159
Pass
4
Last Year
3,015,394
3,015,394
Pass
5
Budget
0
0
Pass
8
TY Quantity
135,758
135,758
Pass
9
LY Quantity
243,398
243,398
Pass
10
Budget Quantity
0
0
Pass

Silhouette Month Subreport : 3930
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
5,589,304
5,589,304
Pass
2
Open
1,775
1,775
Pass
3
Total
5,591,079
5,591,079
Pass
4
Last Year
3,983,225
3,983,225
Pass
5
Budget
7,235,165
7,235,165
Pass
8
TY Quantity
547,081
547,081
Pass
9
LY Quantity
491,967
​491,967
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : CUSTOM 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
4,364,304
4,364,304
Pass
2
Open
13,677
13,677
Pass
3
Total
4,377,982
4,377,982
Pass
4
Last Year
4,253,290
4,253,290
Pass
5
Budget
0
0
Pass
8
TY Quantity
337,462
337,462
Pass
9
LY Quantity
333,224
333,224
Pass
10
Budget Quantity
0
0
Pass

Second Level Check


Test Conducted

Group: North America > Headwear
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
58,189,876
58,189,876
Pass
2
Last Year Shipped YTD
49,414,043
49,414,043
Pass
3
Current Year Budget YTD
71,549,289
71,549,289
Pass
4
Total Open Revenue
112,440,256
112,440,256
Pass
5
Total Shipped Current Year
170,630,133
170,630,133
Pass
6
Total Shipped Last Year
428,369,037
428,369,037
Pass
7
Total Budget Current Year
466,363,103
466,363,103
Pass
8
TY Quantity
5,072,270
5,072,270
Pass
9
LY Quantity
4,726,020
4,726,020
Pass
10
Budget Quantity
0
0
Pass

License Subreport : MLB Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
29,409,332
29,409,332
Pass
2
Open
38,345,124
38,345,124
Pass
3
Total
67,754,456
67,754,456
Pass
4
Last Year
30,673,492
30,673,492
Pass
5
Budget
0
0
Pass
6
TY Quantity
2,313,922
2,313,922
Pass
7
LY Quantity
2,539,906
2,539,906
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : FASHION REG & IND
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
8,381,254
8,381,254
Pass
2
Open
14,574,185
14,574,185
Pass
3
Total
22,955,439
22,955,439
Pass
4
Last Year
6,489,602
6,489,602
Pass
5
Budget
0
0
Pass
6
TY Quantity
589,259
589,259
Pass
7
LY Quantity
460,799
460,799
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : LIDS INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
14,713,243
14,713,243
Pass
2
Open
28,624,695
28,624,695
Pass
3
Total
43,337,937
43,337,937
Pass
4
Last Year
11,475,401
11,475,401
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,166,764
1,166,764
Pass
7
LY Quantity
927,923
927,923
Pass
8
Budget Quantity
0
0
Pass

Silhouette Subreport : 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
31,047,681
31,047,681
Pass
2
Open
41,328,431
41,328,431
Pass
3
Total
72,376,113
72,376,113
Pass
4
Last Year
28,811,657
28,811,657
Pass
5
Budget
0
0
Pass
6
TY Quantity
2,106,764
2,106,764
Pass
7
LY Quantity
2,304,102
2,304,102
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
7,953,441
7,953,441
Pass
2
Open
26,630,593
26,630,593
Pass
3
Total
34,584,033
34,584,033
Pass
4
Last Year
10,841,319
10,841,319
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,165,956
1,165,956
Pass
7
LY Quantity
1,489,738
1,489,738
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
37,569,292
37,569,292
Pass
2
Last Year Shipped MTD
34,253,070
34,253,070
Pass
3
Budget Current Year MTD
48,708,540
48,708,540
Pass
4
TY Quantity Current Year MTD
3,149,765
3,149,765
Pass
5
LY Quantity Last Year MTD
3,194,908
3,194,908
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

License Month Subreport : NBA Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
4,751,026
4,751,026
Pass
2
Open
170,574
170,574
Pass
3
Total
4,921,600
4,921,600
Pass
4
Last Year
4,152,066
4,152,066
Pass
5
Budget
0
0
Pass
6
TY Quantity
401,381
401,381
Pass
7
LY Quantity
362,021
362,021
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : FASHION REG & IND
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
4,700,767
4,700,767
Pass
2
Open
0
0
Pass
3
Total
4,700,767
4,700,767
Pass
4
Last Year
3,517,959
3,517,959
Pass
5
Budget
0
0
Pass
8
TY Quantity
242,787
242,787
Pass
9
LY Quantity
8,381,254
8,381,254
Pass
10
Budget Quantity
0
0
Pass

Customer Subreport : FOOT LOCKER INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
1,162,026
1,162,026
Pass
2
Open
0
0
Pass
3
Total
1,162,026
1,162,026
Pass
4
Last Year
851,140
851,140
Pass
5
Budget
0
0
Pass
8
TY Quantity
101,667
101,667
Pass
9
LY Quantity
76,280
76,280
Pass
10
Budget Quantity
0
0
Pass

Silhouette Month Subreport : 950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
5,833,034
5,833,034
Pass
2
Open
37,424
37,424
Pass
3
Total
5,870,458
5,870,458
Pass
4
Last Year
6,340,575
6,340,575
Pass
5
Budget
0
0
Pass
8
TY Quantity
642,574
642,574
Pass
9
LY Quantity
608,066
608,066
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : AC PERFORMANCE
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
3,909,500
3,909,500
Pass
2
Open
216,249
216,249
Pass
3
Total
4,125,479
4,125,479
Pass
4
Last Year
6,812,110
6,812,110
Pass
5
Budget
0
0
Pass
8
TY Quantity
274,329
274,329
Pass
9
LY Quantity
490,005
490,005
Pass
10
Budget Quantity
0
0
Pass

Third Level Check


Test Conducted

Group: North America > Headwear > United States Sales
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped YTD
55,808,137
55,808,137
Pass
2
Last Year Shipped YTD
46,859,844
46,859,844
Pass
3
Current Year Budget YTD
68,842,375
68,842,375
Pass
4
Total Open Revenue
105,794,917
105,794,917
Pass
5
Total Shipped Current Year
161,603,055
161,603,055
Pass
6
Total Shipped Last Year
46,859,844
46,859,844
Pass
7
Total Budget Current Year
440,918,803
440,918,803
Pass
8
TY Quantity
4,874,931
4,874,931
Pass
9
LY Quantity
4,504,224
4,504,224
Pass
10
Budget Quantity
0
0
Pass

License Subreport : MLB Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
27,816,532
27,816,532
Pass
2
Open
34,888,739
34,888,739
Pass
3
Total
62,705,277
62,705,277
Pass
4
Last Year
28,924,315
28,924,315
Pass
5
Budget
0
0
Pass
6
TY Quantity
2,188,751
2,188,751
Pass
7
LY Quantity
2,393,873
2,393,873
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : FAN SPECIALITY
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
9,177,189
9,177,189
Pass
2
Open
19,250,536
19,250,536
Pass
3
Total
28,427,725
28,427,725
Pass
4
Last Year
4,893,988
4,893,988
Pass
5
Budget
0
0
Pass
6
TY Quantity
692,158
692,158
Pass
7
LY Quantity
407,898
407,898
Pass
8
Budget Quantity
0
0
Pass

Customer Subreport : GSI COMMERCE INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
1,491,458
1,491,458
Pass
2
Open
456,816
456,816
Pass
3
Total
1,948,274
1,948,274
Pass
4
Last Year
157,271
157,271
Pass
5
Budget
0
0
Pass
6
TY Quantity
92,854
92,854
Pass
7
LY Quantity
12,351
12,351
Pass
8
Budget Quantity
0
0
Pass

Silhouette Subreport : 5950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
29,671,313
29,671,313
Pass
2
Open
38,440,071
38,440,071
Pass
3
Total
68,111,384
68,111,384
Pass
4
Last Year
27,173,546
27,173,546
Pass
5
Budget
0
0
Pass
6
TY Quantity
2,025,157
2,025,157
Pass
7
LY Quantity
2,188,488
2,188,488
Pass
8
Budget Quantity
0
0
Pass

Collection Subreport : CUSTOM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
7,608,625
7,608,625
Pass
2
Open
25,473,153
25,473,153
Pass
3
Total
33,081,778
33,081,778
Pass
4
Last Year
10,571,142
10,571,142
Pass
5
Budget
0
0
Pass
6
TY Quantity
1,125,694
1,125,694
Pass
7
LY Quantity
1,451,297
1,451,297
Pass
8
Budget Quantity
0
0
Pass

Current Month Reports:
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Current Year Shipped MTD
36,030,713
36,030,713
Pass
2
Last Year Shipped MTD
32,396,458
32,396,458
Pass
3
Budget Current Year MTD
46,896,532
46,896,532
Pass
4
TY Quantity Current Year MTD
3,038,512
3,038,512
Pass
5
LY Quantity Last Year MTD
3,037,654
3,037,654
Pass
6
Budget Quantity Current Year MTD
0
0
Pass

License Month Subreport : NBA Properties
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
4,585,783
4,585,783
Pass
2
Open
170,574
170,574
Pass
3
Total
4,756,358
4,756,358
Pass
4
Last Year
3,979,096
3,979,096
Pass
5
Budget
0
0
Pass
6
TY Quantity
386,475
386,475
Pass
7
LY Quantity
349,719
349,719
Pass
8
Budget Quantity
0
0
Pass

Customer Segment Subreport : CONCESSIONAIRE & STADIUM
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
3,597,387
3,597,387
Pass
2
Open
3,820
3,820
Pass
3
Total
3,601,208
3,601,208
Pass
4
Last Year
4,102,847
4,102,847
Pass
5
Budget
0
0
Pass
8
TY Quantity
374,094
374,094
Pass
9
LY Quantity
418,701
418,701
Pass
10
Budget Quantity
0
0
Pass

Customer Subreport : GSI COMMERCE INC
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
787,849
787,849
Pass
2
Open
170574
170,574
Pass
3
Total
958,423
958423
Pass
4
Last Year
18,533
18,533
Pass
5
Budget
0
0
Pass
8
TY Quantity
48,094
48,094
Pass
9
LY Quantity
1,632
1,632
Pass
10
Budget Quantity
0
0
Pass

Silhouette Month Subreport : 950
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
5,610,484
5,610,484
Pass
2
Open
37,424
37,424
Pass
3
Total
5,647,908
5,647,908
Pass
4
Last Year
6,003,412
6,003,412
Pass
5
Budget
0
0
Pass
8
TY Quantity
619,716
619,716
Pass
9
LY Quantity
581,132
581,132
Pass
10
Budget Quantity
0
0
Pass

Collection Month Subreport : AC PERFORMANCE
SNo
Test Case
Value in CR
Value in BEx/Budget Sheet
Pass/Fail Criteria
1
Shipped
3,758,074
3,758,074
Pass
2
Open
0
0
Pass
3
Total
3,758,074
3,758,074
Pass
4
Last Year
6,373,247
6,373,247
Pass
5
Budget
0
0
Pass
8
TY Quantity
265,546
265,546
Pass
9
LY Quantity
460,863
460,863
Pass
10
Budget Quantity
0
0
Pass

Reference Document(Specification)


2013-03-15 - 5910.200 - Spec - Contract Reports